import os
import sys
import easygui #pip install easygui
import pathlib
import time
from openpyxl import Workbook
import inc
import xlrd3 
print(time.strftime("%Y",time.localtime()))
root=pathlib.Path(os.path.dirname(os.path.realpath(sys.argv[0])))
mergepath=root/"merge"
pathlib.Path(mergepath).mkdir(parents=True, exist_ok=True) #创建文件夹
for ifile in pathlib.Path(mergepath).iterdir():
    print(ifile)
    wb = xlrd3.open_workbook(str(ifile))

title=easygui.enterbox("文件名",default="{}年第 次周考统计".format(time.localtime(time.time()).tm_year))
print(title)